Description: Excel file containing extracts of utilization and costs for chiropractic and acupunture - all members combined. From a research project examining the utility of standard eligibility and claims extracts for complementary and alternative medical therapies - CAM analysis.

Description: Long Term Care Think Tank: Exploring the possibilities for helping the American public manage the financial burden of long term care. This report shares the output of a 1.5 day structured brainstorming session involving some of the LTC industry’s preeminent thought leaders. Ideas presented here are intended to help transform the delivery, accessibility, and financing of long term care.

Description: This is an Excel 2003 spreadsheet that accompanies the research report entitled 'The Effect of Deflation or High Inflation on the Insurance Industry.' It models scholastically the effects of inflation and deflation.

Description: The Health Section Research Team is pleased to make available the following research study and Excel model that provide a framework for estimating the financial impact of health plan provider network risk. The research was conducted by the Denver office of Milliman, Inc. The Excel workbook allows the user to assess cost implications of aspects of network risk under various assumptions. The assumptions in the workbook can be altered by the user and be applied to test a range of scenarios.

Description: The Required Minimum Distribution [RMD] Working Group of the SOA Taxation Section has completed research identifying considerations for actuaries and annuity insurers in determing the actuarial present value of additional benefits for computing the RMD under a deferred annuity contract. This is the Appendix I spreadsheet for determining the Actuarial Present Value of an annuitization bonus. Please see the SOA website research for the full report and other associated spreadsheets.

Description: This is an Excel workbook containing links to papers, articles and newsletters which are useful to the study of the principles of finance and their application to pension plans. Topics include accounting, assumptions/methods, actuarial standards, behavioral economics, design, financial economics, full funding, immunization, investments, minimum funding, market value, pension finance, PBGC, risk, and traditional defined benefit view. For each document listed in the workbook, its abstract or a short synopsis is also included to help the user choose appropriate readings.

Description: This is an Excel workbook that contains detailed reviews of the literature that was searched in the course of a study that explored pre-retirement influences on attitudes and decisions regarding retirement. The research study, conducted by Linda Smith Brothers, reviewed sixty papers written since 1990, and summarized their important points under several categories. The workbook contains a description of the specific categories covered and how they are addressed by each of the sixty papers that were reviewed.

Description: Recognizing an opportunity to help serve its members in this age of increased financial oversight, the Health Section of the Society of Actuaries commissioned a series of guides on the use of statistical techniques specifically geared for the work of health actuaries. The first guide in the series titled, 'Statistical Methods for Health Actuaries - IBNR Estimates: An Introduction,' is about the calculation of incurred but not reported [IBNR] health claims reserves. In particular, the guide focuses on the development of confidence intervals around IBNR estimates. This is an Excel workbook created to demonstrate the techniques discussed in the guide.

Description: The Preferred Mortality Valuation Table Team prepared this presentation for the June 2008 NAIC LHATF Meeting. The Adobe Acrobat file on the SOA website for experience studies contains the presentation.This Excel workbook is a tool the valuation table team is using to develop values relating to margins for the new valuation mortality table. The purpose of the workbook is to evaluate different margin formulas and valuation tables. Also used for analysis of mortality margins on Valuation Basic Tables.